﻿USE [RestaurantManagement]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		<Nguyễn Đức Thắng>
-- Create date: <15/03/2013>
-- =============================================
CREATE PROCEDURE [dbo].[Update_Restaurant] 
		@RestaurantID as uniqueidentifier,
		@RestaurantCode as varchar(20),
		@RestaurantName as nvarchar(255),
		@Address as nvarchar(255),
		@PhoneNumber as varchar(20),
		@Fax as varchar(20),
		@Email as varchar(100),
		@Website as varchar(100),
		@TaxCode as varchar(20),
		@IsAgencies as bit,
		@IsActive as bit,
		@Description as nvarchar(255)
 as 
		UPDATE dbo.[Restaurant] SET 
			RestaurantID= @RestaurantID,
			RestaurantCode= @RestaurantCode,
			RestaurantName= @RestaurantName,
			Address= @Address,
			PhoneNumber= @PhoneNumber,
			Fax= @Fax,
			Email= @Email,
			Website= @Website,
			TaxCode= @TaxCode,
			IsAgencies= @IsAgencies,
			IsActive= @IsActive,
			Description= @Description
		 WHERE 	(@RestaurantID=dbo.[Restaurant].RestaurantID)

GO
